﻿


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace DataModel {
	
        /// <summary>
        /// Table: D_Invoice
        /// Primary Key: InvoiceNo
        /// </summary>

        public class D_InvoiceStructs: DatabaseTable {
            
            public D_InvoiceStructs(IDataProvider provider):base("D_Invoice",provider){
                ClassName = "D_Invoice";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("InvoiceNo", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "InvoiceNo"
                });

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("InvoiceType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "InvoiceType"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("InvoiceDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InvoiceDate"
                });

                Columns.Add(new DatabaseColumn("ValueAddedTax", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ValueAddedTax"
                });

                Columns.Add(new DatabaseColumn("Price", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Price"
                });

                Columns.Add(new DatabaseColumn("TotalPrice", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TotalPrice"
                });

                Columns.Add(new DatabaseColumn("memo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200,
					PropertyName = "memo"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn InvoiceNo{
                get{
                    return this.GetColumn("InvoiceNo");
                }
            }
				
            
            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn InvoiceType{
                get{
                    return this.GetColumn("InvoiceType");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn InvoiceDate{
                get{
                    return this.GetColumn("InvoiceDate");
                }
            }
				
            
            public IColumn ValueAddedTax{
                get{
                    return this.GetColumn("ValueAddedTax");
                }
            }
				
            
            public IColumn Price{
                get{
                    return this.GetColumn("Price");
                }
            }
				
            
            public IColumn TotalPrice{
                get{
                    return this.GetColumn("TotalPrice");
                }
            }
				
            
            public IColumn memo{
                get{
                    return this.GetColumn("memo");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: D_Reconciliation
        /// Primary Key: ReconciliationNo
        /// </summary>

        public class D_ReconciliationStructs: DatabaseTable {
            
            public D_ReconciliationStructs(IDataProvider provider):base("D_Reconciliation",provider){
                ClassName = "D_Reconciliation";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("TotalPrice", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TotalPrice"
                });

                Columns.Add(new DatabaseColumn("PaidPrice", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "PaidPrice"
                });

                Columns.Add(new DatabaseColumn("AccountingDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "AccountingDate"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn TotalPrice{
                get{
                    return this.GetColumn("TotalPrice");
                }
            }
				
            
            public IColumn PaidPrice{
                get{
                    return this.GetColumn("PaidPrice");
                }
            }
				
            
            public IColumn AccountingDate{
                get{
                    return this.GetColumn("AccountingDate");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: D_ShopPO
        /// Primary Key: OrderID
        /// </summary>

        public class D_ShopPOStructs: DatabaseTable {
            
            public D_ShopPOStructs(IDataProvider provider):base("D_ShopPO",provider){
                ClassName = "D_ShopPO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("SupplierName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SupplierName"
                });

                Columns.Add(new DatabaseColumn("ShopCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "ShopCode"
                });

                Columns.Add(new DatabaseColumn("ShopName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "ShopName"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("SumKindQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SumKindQty"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("AllocationQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "AllocationQty"
                });

                Columns.Add(new DatabaseColumn("DeliveryQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DeliveryQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("DeliveryTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DeliveryTime"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("SaleType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SaleType"
                });

                Columns.Add(new DatabaseColumn("DeptCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DeptCode"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("Cost2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost2"
                });

                Columns.Add(new DatabaseColumn("Selling1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling1"
                });

                Columns.Add(new DatabaseColumn("Selling2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling2"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("PrintTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "PrintTime"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("VehicleNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "VehicleNo"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn SupplierName{
                get{
                    return this.GetColumn("SupplierName");
                }
            }
				
            
            public IColumn ShopCode{
                get{
                    return this.GetColumn("ShopCode");
                }
            }
				
            
            public IColumn ShopName{
                get{
                    return this.GetColumn("ShopName");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn SumKindQty{
                get{
                    return this.GetColumn("SumKindQty");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn AllocationQty{
                get{
                    return this.GetColumn("AllocationQty");
                }
            }
				
            
            public IColumn DeliveryQty{
                get{
                    return this.GetColumn("DeliveryQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn DeliveryTime{
                get{
                    return this.GetColumn("DeliveryTime");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn SaleType{
                get{
                    return this.GetColumn("SaleType");
                }
            }
				
            
            public IColumn DeptCode{
                get{
                    return this.GetColumn("DeptCode");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn Cost2{
                get{
                    return this.GetColumn("Cost2");
                }
            }
				
            
            public IColumn Selling1{
                get{
                    return this.GetColumn("Selling1");
                }
            }
				
            
            public IColumn Selling2{
                get{
                    return this.GetColumn("Selling2");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn PrintTime{
                get{
                    return this.GetColumn("PrintTime");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn VehicleNo{
                get{
                    return this.GetColumn("VehicleNo");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: D_ShopRO
        /// Primary Key: OrderID
        /// </summary>

        public class D_ShopROStructs: DatabaseTable {
            
            public D_ShopROStructs(IDataProvider provider):base("D_ShopRO",provider){
                ClassName = "D_ShopRO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("SupplierName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SupplierName"
                });

                Columns.Add(new DatabaseColumn("ShopCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "ShopCode"
                });

                Columns.Add(new DatabaseColumn("ShopName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "ShopName"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("SumKindQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SumKindQty"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("ReclaimQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ReclaimQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("ReclaimTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ReclaimTime"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("DeptCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DeptCode"
                });

                Columns.Add(new DatabaseColumn("SaleType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SaleType"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("Cost2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost2"
                });

                Columns.Add(new DatabaseColumn("Selling1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling1"
                });

                Columns.Add(new DatabaseColumn("Selling2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling2"
                });

                Columns.Add(new DatabaseColumn("ReturnReason", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100,
					PropertyName = "ReturnReason"
                });

                Columns.Add(new DatabaseColumn("GoodsStatus", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsStatus"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("PrintTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "PrintTime"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn SupplierName{
                get{
                    return this.GetColumn("SupplierName");
                }
            }
				
            
            public IColumn ShopCode{
                get{
                    return this.GetColumn("ShopCode");
                }
            }
				
            
            public IColumn ShopName{
                get{
                    return this.GetColumn("ShopName");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn SumKindQty{
                get{
                    return this.GetColumn("SumKindQty");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn ReclaimQty{
                get{
                    return this.GetColumn("ReclaimQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn ReclaimTime{
                get{
                    return this.GetColumn("ReclaimTime");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn DeptCode{
                get{
                    return this.GetColumn("DeptCode");
                }
            }
				
            
            public IColumn SaleType{
                get{
                    return this.GetColumn("SaleType");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn Cost2{
                get{
                    return this.GetColumn("Cost2");
                }
            }
				
            
            public IColumn Selling1{
                get{
                    return this.GetColumn("Selling1");
                }
            }
				
            
            public IColumn Selling2{
                get{
                    return this.GetColumn("Selling2");
                }
            }
				
            
            public IColumn ReturnReason{
                get{
                    return this.GetColumn("ReturnReason");
                }
            }
				
            
            public IColumn GoodsStatus{
                get{
                    return this.GetColumn("GoodsStatus");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn PrintTime{
                get{
                    return this.GetColumn("PrintTime");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: D_SupplierPO
        /// Primary Key: OrderID
        /// </summary>

        public class D_SupplierPOStructs: DatabaseTable {
            
            public D_SupplierPOStructs(IDataProvider provider):base("D_SupplierPO",provider){
                ClassName = "D_SupplierPO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("MailTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MailTypeCode"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("VehicleNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "VehicleNo"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn MailTypeCode{
                get{
                    return this.GetColumn("MailTypeCode");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn VehicleNo{
                get{
                    return this.GetColumn("VehicleNo");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: D_SupplierRO
        /// Primary Key: OrderID
        /// </summary>

        public class D_SupplierROStructs: DatabaseTable {
            
            public D_SupplierROStructs(IDataProvider provider):base("D_SupplierRO",provider){
                ClassName = "D_SupplierRO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("MailTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MailTypeCode"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("VehicleNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "VehicleNo"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn MailTypeCode{
                get{
                    return this.GetColumn("MailTypeCode");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn VehicleNo{
                get{
                    return this.GetColumn("VehicleNo");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_Company
        /// Primary Key: Code
        /// </summary>

        public class M_CompanyStructs: DatabaseTable {
            
            public M_CompanyStructs(IDataProvider provider):base("M_Company",provider){
                ClassName = "M_Company";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "Code"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("NameEN", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "NameEN"
                });

                Columns.Add(new DatabaseColumn("FullName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "FullName"
                });

                Columns.Add(new DatabaseColumn("Symbol", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 5,
					PropertyName = "Symbol"
                });

                Columns.Add(new DatabaseColumn("Address", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 30,
					PropertyName = "Address"
                });

                Columns.Add(new DatabaseColumn("Tel", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Tel"
                });

                Columns.Add(new DatabaseColumn("Fax", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Fax"
                });

                Columns.Add(new DatabaseColumn("ZipCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ZipCode"
                });

                Columns.Add(new DatabaseColumn("Email", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 30,
					PropertyName = "Email"
                });

                Columns.Add(new DatabaseColumn("TaxRate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TaxRate"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn NameEN{
                get{
                    return this.GetColumn("NameEN");
                }
            }
				
            
            public IColumn FullName{
                get{
                    return this.GetColumn("FullName");
                }
            }
				
            
            public IColumn Symbol{
                get{
                    return this.GetColumn("Symbol");
                }
            }
				
            
            public IColumn Address{
                get{
                    return this.GetColumn("Address");
                }
            }
				
            
            public IColumn Tel{
                get{
                    return this.GetColumn("Tel");
                }
            }
				
            
            public IColumn Fax{
                get{
                    return this.GetColumn("Fax");
                }
            }
				
            
            public IColumn ZipCode{
                get{
                    return this.GetColumn("ZipCode");
                }
            }
				
            
            public IColumn Email{
                get{
                    return this.GetColumn("Email");
                }
            }
				
            
            public IColumn TaxRate{
                get{
                    return this.GetColumn("TaxRate");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_Dept
        /// Primary Key: DeptCode
        /// </summary>

        public class M_DeptStructs: DatabaseTable {
            
            public M_DeptStructs(IDataProvider provider):base("M_Dept",provider){
                ClassName = "M_Dept";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("DIVCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DIVCode"
                });

                Columns.Add(new DatabaseColumn("DeptCode", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DeptCode"
                });

                Columns.Add(new DatabaseColumn("ClassCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "ClassCode"
                });

                Columns.Add(new DatabaseColumn("DeptName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "DeptName"
                });

                Columns.Add(new DatabaseColumn("SupplyTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "SupplyTypeCode"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("DayLimitCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayLimitCode"
                });

                Columns.Add(new DatabaseColumn("TaxTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "TaxTypeCode"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn DIVCode{
                get{
                    return this.GetColumn("DIVCode");
                }
            }
				
            
            public IColumn DeptCode{
                get{
                    return this.GetColumn("DeptCode");
                }
            }
				
            
            public IColumn ClassCode{
                get{
                    return this.GetColumn("ClassCode");
                }
            }
				
            
            public IColumn DeptName{
                get{
                    return this.GetColumn("DeptName");
                }
            }
				
            
            public IColumn SupplyTypeCode{
                get{
                    return this.GetColumn("SupplyTypeCode");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn DayLimitCode{
                get{
                    return this.GetColumn("DayLimitCode");
                }
            }
				
            
            public IColumn TaxTypeCode{
                get{
                    return this.GetColumn("TaxTypeCode");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_Goods
        /// Primary Key: GoodsCode
        /// </summary>

        public class M_GoodsStructs: DatabaseTable {
            
            public M_GoodsStructs(IDataProvider provider):base("M_Goods",provider){
                ClassName = "M_Goods";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "EANType"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("MailType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MailType"
                });

                Columns.Add(new DatabaseColumn("DIVCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DIVCode"
                });

                Columns.Add(new DatabaseColumn("DeptCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "DeptCode"
                });

                Columns.Add(new DatabaseColumn("ClassCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "ClassCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("POSName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "POSName"
                });

                Columns.Add(new DatabaseColumn("PCFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "PCFlg"
                });

                Columns.Add(new DatabaseColumn("PCType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "PCType"
                });

                Columns.Add(new DatabaseColumn("Home", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 12,
					PropertyName = "Home"
                });

                Columns.Add(new DatabaseColumn("Rank", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "Rank"
                });

                Columns.Add(new DatabaseColumn("Standard", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 14,
					PropertyName = "Standard"
                });

                Columns.Add(new DatabaseColumn("Unit", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 4,
					PropertyName = "Unit"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("GoodsSign", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsSign"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("Cost2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost2"
                });

                Columns.Add(new DatabaseColumn("Cost3", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost3"
                });

                Columns.Add(new DatabaseColumn("Cost4", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost4"
                });

                Columns.Add(new DatabaseColumn("Selling1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling1"
                });

                Columns.Add(new DatabaseColumn("Selling2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Selling2"
                });

                Columns.Add(new DatabaseColumn("Percentage", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Single,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Percentage"
                });

                Columns.Add(new DatabaseColumn("OrderFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderFlg"
                });

                Columns.Add(new DatabaseColumn("SaleFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SaleFlg"
                });

                Columns.Add(new DatabaseColumn("MaxVolume", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "MaxVolume"
                });

                Columns.Add(new DatabaseColumn("MinVolume", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "MinVolume"
                });

                Columns.Add(new DatabaseColumn("AddVolume", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "AddVolume"
                });

                Columns.Add(new DatabaseColumn("Quantity", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Quantity"
                });

                Columns.Add(new DatabaseColumn("StartDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StartDate"
                });

                Columns.Add(new DatabaseColumn("FirstDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "FirstDate"
                });

                Columns.Add(new DatabaseColumn("DeliveryType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DeliveryType"
                });

                Columns.Add(new DatabaseColumn("MaintenanceFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MaintenanceFlg"
                });

                Columns.Add(new DatabaseColumn("PickType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "PickType"
                });

                Columns.Add(new DatabaseColumn("FFFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "FFFlg"
                });

                Columns.Add(new DatabaseColumn("OrderBeginDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderBeginDate"
                });

                Columns.Add(new DatabaseColumn("OrderEndDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderEndDate"
                });

                Columns.Add(new DatabaseColumn("TmpSaleFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TmpSaleFlg"
                });

                Columns.Add(new DatabaseColumn("ReturnFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ReturnFlg"
                });

                Columns.Add(new DatabaseColumn("SendType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SendType"
                });

                Columns.Add(new DatabaseColumn("DeadlineUnit", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "DeadlineUnit"
                });

                Columns.Add(new DatabaseColumn("DeadlineOrder", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DeadlineOrder"
                });

                Columns.Add(new DatabaseColumn("DeadlineSale", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DeadlineSale"
                });

                Columns.Add(new DatabaseColumn("SendDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendDate"
                });

                Columns.Add(new DatabaseColumn("SendFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "SendFlg"
                });

                Columns.Add(new DatabaseColumn("BarcodeFlg", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "BarcodeFlg"
                });

                Columns.Add(new DatabaseColumn("TouchOrder", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TouchOrder"
                });

                Columns.Add(new DatabaseColumn("BoxQuantity", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "BoxQuantity"
                });

                Columns.Add(new DatabaseColumn("SafetyStock", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SafetyStock"
                });

                Columns.Add(new DatabaseColumn("SupplierCode2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode2"
                });

                Columns.Add(new DatabaseColumn("OrderFlg2", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderFlg2"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANType{
                get{
                    return this.GetColumn("EANType");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn MailType{
                get{
                    return this.GetColumn("MailType");
                }
            }
				
            
            public IColumn DIVCode{
                get{
                    return this.GetColumn("DIVCode");
                }
            }
				
            
            public IColumn DeptCode{
                get{
                    return this.GetColumn("DeptCode");
                }
            }
				
            
            public IColumn ClassCode{
                get{
                    return this.GetColumn("ClassCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn POSName{
                get{
                    return this.GetColumn("POSName");
                }
            }
				
            
            public IColumn PCFlg{
                get{
                    return this.GetColumn("PCFlg");
                }
            }
				
            
            public IColumn PCType{
                get{
                    return this.GetColumn("PCType");
                }
            }
				
            
            public IColumn Home{
                get{
                    return this.GetColumn("Home");
                }
            }
				
            
            public IColumn Rank{
                get{
                    return this.GetColumn("Rank");
                }
            }
				
            
            public IColumn Standard{
                get{
                    return this.GetColumn("Standard");
                }
            }
				
            
            public IColumn Unit{
                get{
                    return this.GetColumn("Unit");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn GoodsSign{
                get{
                    return this.GetColumn("GoodsSign");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn Cost2{
                get{
                    return this.GetColumn("Cost2");
                }
            }
				
            
            public IColumn Cost3{
                get{
                    return this.GetColumn("Cost3");
                }
            }
				
            
            public IColumn Cost4{
                get{
                    return this.GetColumn("Cost4");
                }
            }
				
            
            public IColumn Selling1{
                get{
                    return this.GetColumn("Selling1");
                }
            }
				
            
            public IColumn Selling2{
                get{
                    return this.GetColumn("Selling2");
                }
            }
				
            
            public IColumn Percentage{
                get{
                    return this.GetColumn("Percentage");
                }
            }
				
            
            public IColumn OrderFlg{
                get{
                    return this.GetColumn("OrderFlg");
                }
            }
				
            
            public IColumn SaleFlg{
                get{
                    return this.GetColumn("SaleFlg");
                }
            }
				
            
            public IColumn MaxVolume{
                get{
                    return this.GetColumn("MaxVolume");
                }
            }
				
            
            public IColumn MinVolume{
                get{
                    return this.GetColumn("MinVolume");
                }
            }
				
            
            public IColumn AddVolume{
                get{
                    return this.GetColumn("AddVolume");
                }
            }
				
            
            public IColumn Quantity{
                get{
                    return this.GetColumn("Quantity");
                }
            }
				
            
            public IColumn StartDate{
                get{
                    return this.GetColumn("StartDate");
                }
            }
				
            
            public IColumn FirstDate{
                get{
                    return this.GetColumn("FirstDate");
                }
            }
				
            
            public IColumn DeliveryType{
                get{
                    return this.GetColumn("DeliveryType");
                }
            }
				
            
            public IColumn MaintenanceFlg{
                get{
                    return this.GetColumn("MaintenanceFlg");
                }
            }
				
            
            public IColumn PickType{
                get{
                    return this.GetColumn("PickType");
                }
            }
				
            
            public IColumn FFFlg{
                get{
                    return this.GetColumn("FFFlg");
                }
            }
				
            
            public IColumn OrderBeginDate{
                get{
                    return this.GetColumn("OrderBeginDate");
                }
            }
				
            
            public IColumn OrderEndDate{
                get{
                    return this.GetColumn("OrderEndDate");
                }
            }
				
            
            public IColumn TmpSaleFlg{
                get{
                    return this.GetColumn("TmpSaleFlg");
                }
            }
				
            
            public IColumn ReturnFlg{
                get{
                    return this.GetColumn("ReturnFlg");
                }
            }
				
            
            public IColumn SendType{
                get{
                    return this.GetColumn("SendType");
                }
            }
				
            
            public IColumn DeadlineUnit{
                get{
                    return this.GetColumn("DeadlineUnit");
                }
            }
				
            
            public IColumn DeadlineOrder{
                get{
                    return this.GetColumn("DeadlineOrder");
                }
            }
				
            
            public IColumn DeadlineSale{
                get{
                    return this.GetColumn("DeadlineSale");
                }
            }
				
            
            public IColumn SendDate{
                get{
                    return this.GetColumn("SendDate");
                }
            }
				
            
            public IColumn SendFlg{
                get{
                    return this.GetColumn("SendFlg");
                }
            }
				
            
            public IColumn BarcodeFlg{
                get{
                    return this.GetColumn("BarcodeFlg");
                }
            }
				
            
            public IColumn TouchOrder{
                get{
                    return this.GetColumn("TouchOrder");
                }
            }
				
            
            public IColumn BoxQuantity{
                get{
                    return this.GetColumn("BoxQuantity");
                }
            }
				
            
            public IColumn SafetyStock{
                get{
                    return this.GetColumn("SafetyStock");
                }
            }
				
            
            public IColumn SupplierCode2{
                get{
                    return this.GetColumn("SupplierCode2");
                }
            }
				
            
            public IColumn OrderFlg2{
                get{
                    return this.GetColumn("OrderFlg2");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_ReconciliationStatus
        /// Primary Key: ReconciliationStatusId
        /// </summary>

        public class M_ReconciliationStatusStructs: DatabaseTable {
            
            public M_ReconciliationStatusStructs(IDataProvider provider):base("M_ReconciliationStatus",provider){
                ClassName = "M_ReconciliationStatus";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ReconciliationStatusId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0,
					PropertyName = "ReconciliationStatusId"
                });

                Columns.Add(new DatabaseColumn("StatusName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "StatusName"
                });

                Columns.Add(new DatabaseColumn("Description", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100,
					PropertyName = "Description"
                });
                    
                
                
            }

            public IColumn ReconciliationStatusId{
                get{
                    return this.GetColumn("ReconciliationStatusId");
                }
            }
				
            
            public IColumn StatusName{
                get{
                    return this.GetColumn("StatusName");
                }
            }
				
            
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_Shop
        /// Primary Key: Code
        /// </summary>

        public class M_ShopStructs: DatabaseTable {
            
            public M_ShopStructs(IDataProvider provider):base("M_Shop",provider){
                ClassName = "M_Shop";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "Code"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("Phone", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Phone"
                });

                Columns.Add(new DatabaseColumn("Address", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100,
					PropertyName = "Address"
                });

                Columns.Add(new DatabaseColumn("ShopTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "ShopTypeCode"
                });

                Columns.Add(new DatabaseColumn("StartDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StartDate"
                });

                Columns.Add(new DatabaseColumn("EndDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "EndDate"
                });

                Columns.Add(new DatabaseColumn("Delivery_Priority", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2,
					PropertyName = "Delivery_Priority"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn Phone{
                get{
                    return this.GetColumn("Phone");
                }
            }
				
            
            public IColumn Address{
                get{
                    return this.GetColumn("Address");
                }
            }
				
            
            public IColumn ShopTypeCode{
                get{
                    return this.GetColumn("ShopTypeCode");
                }
            }
				
            
            public IColumn StartDate{
                get{
                    return this.GetColumn("StartDate");
                }
            }
				
            
            public IColumn EndDate{
                get{
                    return this.GetColumn("EndDate");
                }
            }
				
            
            public IColumn Delivery_Priority{
                get{
                    return this.GetColumn("Delivery_Priority");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_StatusCode
        /// Primary Key: StatusCode
        /// </summary>

        public class M_StatusCodeStructs: DatabaseTable {
            
            public M_StatusCodeStructs(IDataProvider provider):base("M_StatusCode",provider){
                ClassName = "M_StatusCode";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("StatusName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "StatusName"
                });
                    
                
                
            }

            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn StatusName{
                get{
                    return this.GetColumn("StatusName");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_Supplier
        /// Primary Key: Code
        /// </summary>

        public class M_SupplierStructs: DatabaseTable {
            
            public M_SupplierStructs(IDataProvider provider):base("M_Supplier",provider){
                ClassName = "M_Supplier";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 6,
					PropertyName = "Code"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("Password", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Password"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn Password{
                get{
                    return this.GetColumn("Password");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: M_SysCode
        /// Primary Key: Code
        /// </summary>

        public class M_SysCodeStructs: DatabaseTable {
            
            public M_SysCodeStructs(IDataProvider provider):base("M_SysCode",provider){
                ClassName = "M_SysCode";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Kbn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3,
					PropertyName = "Kbn"
                });

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "Code"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn Kbn{
                get{
                    return this.GetColumn("Kbn");
                }
            }
				
            
            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: R_ReconciliationAndOrder
        /// Primary Key: DetailNo
        /// </summary>

        public class R_ReconciliationAndOrderStructs: DatabaseTable {
            
            public R_ReconciliationAndOrderStructs(IDataProvider provider):base("R_ReconciliationAndOrder",provider){
                ClassName = "R_ReconciliationAndOrder";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("OrderType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderType"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });
                    
                
                
            }

            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn OrderType{
                get{
                    return this.GetColumn("OrderType");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: View_Reconciliation
        /// Primary Key: 
        /// </summary>

        public class View_ReconciliationStructs: DatabaseTable {
            
            public View_ReconciliationStructs(IDataProvider provider):base("View_Reconciliation",provider){
                ClassName = "View_Reconciliation";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("StatusName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "StatusName"
                });

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("TotalPrice", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TotalPrice"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("PaidPrice", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "PaidPrice"
                });

                Columns.Add(new DatabaseColumn("AccountingDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "AccountingDate"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "SendUser"
                });
                    
                
                
            }

            public IColumn StatusName{
                get{
                    return this.GetColumn("StatusName");
                }
            }
				
            
            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn TotalPrice{
                get{
                    return this.GetColumn("TotalPrice");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn PaidPrice{
                get{
                    return this.GetColumn("PaidPrice");
                }
            }
				
            
            public IColumn AccountingDate{
                get{
                    return this.GetColumn("AccountingDate");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: View_SupplierPO
        /// Primary Key: 
        /// </summary>

        public class View_SupplierPOStructs: DatabaseTable {
            
            public View_SupplierPOStructs(IDataProvider provider):base("View_SupplierPO",provider){
                ClassName = "View_SupplierPO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("MailTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MailTypeCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("VehicleNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "VehicleNo"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("StatusName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "StatusName"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn MailTypeCode{
                get{
                    return this.GetColumn("MailTypeCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn VehicleNo{
                get{
                    return this.GetColumn("VehicleNo");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn StatusName{
                get{
                    return this.GetColumn("StatusName");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: View_SupplierPOMaster
        /// Primary Key: 
        /// </summary>

        public class View_SupplierPOMasterStructs: DatabaseTable {
            
            public View_SupplierPOMasterStructs(IDataProvider provider):base("View_SupplierPOMaster",provider){
                ClassName = "View_SupplierPOMaster";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("TotalCost", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TotalCost"
                });
                    
                
                
            }

            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn TotalCost{
                get{
                    return this.GetColumn("TotalCost");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: View_SupplierRO
        /// Primary Key: 
        /// </summary>

        public class View_SupplierROStructs: DatabaseTable {
            
            public View_SupplierROStructs(IDataProvider provider):base("View_SupplierRO",provider){
                ClassName = "View_SupplierRO";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderID", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderID"
                });

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("DetailNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "DetailNo"
                });

                Columns.Add(new DatabaseColumn("GoodsCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "GoodsCode"
                });

                Columns.Add(new DatabaseColumn("EANCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "EANCode"
                });

                Columns.Add(new DatabaseColumn("GoodsName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "GoodsName"
                });

                Columns.Add(new DatabaseColumn("MailTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "MailTypeCode"
                });

                Columns.Add(new DatabaseColumn("TaxType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "TaxType"
                });

                Columns.Add(new DatabaseColumn("DayTypeCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1,
					PropertyName = "DayTypeCode"
                });

                Columns.Add(new DatabaseColumn("Cost1", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "Cost1"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("OrderQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderQty"
                });

                Columns.Add(new DatabaseColumn("ActualQty", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualQty"
                });

                Columns.Add(new DatabaseColumn("VehicleNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "VehicleNo"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("HopeDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "HopeDate"
                });

                Columns.Add(new DatabaseColumn("ActualTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ActualTime"
                });

                Columns.Add(new DatabaseColumn("Remark", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20,
					PropertyName = "Remark"
                });

                Columns.Add(new DatabaseColumn("InsTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "InsTime"
                });

                Columns.Add(new DatabaseColumn("InsUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "InsUser"
                });

                Columns.Add(new DatabaseColumn("UpdTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "UpdTime"
                });

                Columns.Add(new DatabaseColumn("UpdUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "UpdUser"
                });

                Columns.Add(new DatabaseColumn("ConfirmTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "ConfirmTime"
                });

                Columns.Add(new DatabaseColumn("ConfirmUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "ConfirmUser"
                });

                Columns.Add(new DatabaseColumn("SendTime", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "SendTime"
                });

                Columns.Add(new DatabaseColumn("SendUser", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 10,
					PropertyName = "SendUser"
                });

                Columns.Add(new DatabaseColumn("ReconciliationNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 30,
					PropertyName = "ReconciliationNo"
                });

                Columns.Add(new DatabaseColumn("StatusName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "StatusName"
                });
                    
                
                
            }

            public IColumn OrderID{
                get{
                    return this.GetColumn("OrderID");
                }
            }
				
            
            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn DetailNo{
                get{
                    return this.GetColumn("DetailNo");
                }
            }
				
            
            public IColumn GoodsCode{
                get{
                    return this.GetColumn("GoodsCode");
                }
            }
				
            
            public IColumn EANCode{
                get{
                    return this.GetColumn("EANCode");
                }
            }
				
            
            public IColumn GoodsName{
                get{
                    return this.GetColumn("GoodsName");
                }
            }
				
            
            public IColumn MailTypeCode{
                get{
                    return this.GetColumn("MailTypeCode");
                }
            }
				
            
            public IColumn TaxType{
                get{
                    return this.GetColumn("TaxType");
                }
            }
				
            
            public IColumn DayTypeCode{
                get{
                    return this.GetColumn("DayTypeCode");
                }
            }
				
            
            public IColumn Cost1{
                get{
                    return this.GetColumn("Cost1");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn OrderQty{
                get{
                    return this.GetColumn("OrderQty");
                }
            }
				
            
            public IColumn ActualQty{
                get{
                    return this.GetColumn("ActualQty");
                }
            }
				
            
            public IColumn VehicleNo{
                get{
                    return this.GetColumn("VehicleNo");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn HopeDate{
                get{
                    return this.GetColumn("HopeDate");
                }
            }
				
            
            public IColumn ActualTime{
                get{
                    return this.GetColumn("ActualTime");
                }
            }
				
            
            public IColumn Remark{
                get{
                    return this.GetColumn("Remark");
                }
            }
				
            
            public IColumn InsTime{
                get{
                    return this.GetColumn("InsTime");
                }
            }
				
            
            public IColumn InsUser{
                get{
                    return this.GetColumn("InsUser");
                }
            }
				
            
            public IColumn UpdTime{
                get{
                    return this.GetColumn("UpdTime");
                }
            }
				
            
            public IColumn UpdUser{
                get{
                    return this.GetColumn("UpdUser");
                }
            }
				
            
            public IColumn ConfirmTime{
                get{
                    return this.GetColumn("ConfirmTime");
                }
            }
				
            
            public IColumn ConfirmUser{
                get{
                    return this.GetColumn("ConfirmUser");
                }
            }
				
            
            public IColumn SendTime{
                get{
                    return this.GetColumn("SendTime");
                }
            }
				
            
            public IColumn SendUser{
                get{
                    return this.GetColumn("SendUser");
                }
            }
				
            
            public IColumn ReconciliationNo{
                get{
                    return this.GetColumn("ReconciliationNo");
                }
            }
				
            
            public IColumn StatusName{
                get{
                    return this.GetColumn("StatusName");
                }
            }
				
            
                    
        }
        
        /// <summary>
        /// Table: View_SupplierROMaster
        /// Primary Key: 
        /// </summary>

        public class View_SupplierROMasterStructs: DatabaseTable {
            
            public View_SupplierROMasterStructs(IDataProvider provider):base("View_SupplierROMaster",provider){
                ClassName = "View_SupplierROMaster";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("OrderNo", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 15,
					PropertyName = "OrderNo"
                });

                Columns.Add(new DatabaseColumn("SupplierCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 6,
					PropertyName = "SupplierCode"
                });

                Columns.Add(new DatabaseColumn("StatusCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "StatusCode"
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50,
					PropertyName = "Name"
                });

                Columns.Add(new DatabaseColumn("OrderDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "OrderDate"
                });

                Columns.Add(new DatabaseColumn("TotalCost", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Decimal,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0,
					PropertyName = "TotalCost"
                });
                    
                
                
            }

            public IColumn OrderNo{
                get{
                    return this.GetColumn("OrderNo");
                }
            }
				
            
            public IColumn SupplierCode{
                get{
                    return this.GetColumn("SupplierCode");
                }
            }
				
            
            public IColumn StatusCode{
                get{
                    return this.GetColumn("StatusCode");
                }
            }
				
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
            
            public IColumn OrderDate{
                get{
                    return this.GetColumn("OrderDate");
                }
            }
				
            
            public IColumn TotalCost{
                get{
                    return this.GetColumn("TotalCost");
                }
            }
				
            
                    
        }
        
}